UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mYWssdj4DZciuQQeyo33uU8vPIC7fo6rjT0vC/1amqM='
WHERE
key_id = 'd03e2e0af38195c0079f61004bcc4f0d8e1732f0ab47cdef26d645d628b8198c'
AND (
token = 'mYWssdj4DZciuQQeyo33uU8vPIC7fo6rjT0vC/1amqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)