UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zz8qcBV9Npuk26u3Yj+6MtqNy+ScniFpvVMxFVJ7mIQ='
WHERE
key_id = '81dea6b4a5c3a58900ff651fa75f170f1f2fe3269e20749282ba5b5b78347f1e'
AND (
token = 'zz8qcBV9Npuk26u3Yj+6MtqNy+ScniFpvVMxFVJ7mIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)