UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vhBsioG0o9Y6DCxjD7FE/CCq5wml+9uGPOzuiHls4/Y='
WHERE
key_id = 'debe116837f1ed743a4f562c2658743702e7c8f432cfb51753b85b457da24193'
AND (
token = 'vhBsioG0o9Y6DCxjD7FE/CCq5wml+9uGPOzuiHls4/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)