UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W+zNd5+oCum3WaMQQnr1eCr2lA9jGDbGZ3g6x308SX8='
WHERE
key_id = '8f93e76ad578313987b898f63904f12a5745c0a25073d1257d8f5ab7e5168272'
AND (
token = 'W+zNd5+oCum3WaMQQnr1eCr2lA9jGDbGZ3g6x308SX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)