UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pI4/U8N5wU3prEbUajGU/HyX1SAWJuEUwvsuiu60Q+U='
WHERE
key_id = 'a0f01f6fca859ad7a4d0de9939f9ada52114a9adb1d89ca62b6724f43f93ce4e'
AND (
token = 'pI4/U8N5wU3prEbUajGU/HyX1SAWJuEUwvsuiu60Q+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)