UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jl2YvXkGUXaHC/p4lBuwXAOKvtsu4Az2MoCl+fSEa2o='
WHERE
key_id = 'a0186f8e75837c84235c615130d93d014905d51faf9a7f58e0a57412a4f1109a'
AND (
token = 'jl2YvXkGUXaHC/p4lBuwXAOKvtsu4Az2MoCl+fSEa2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)