UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPH0ndUX15YYUpJFJWIfyySPFraZpTQ20LuNFUrx3VY='
WHERE
key_id = 'ae8409aa8e0d07a43f543c195cc5138454ff769ef4974fecffd343f03b56fd53'
AND (
token = 'sPH0ndUX15YYUpJFJWIfyySPFraZpTQ20LuNFUrx3VY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)