UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1O8qgrlV9p7tAnTeSz9u9T/icl78Vjzcl8LK3rx94A='
WHERE
key_id = '50d847d4c655e9511bf177caa0681e5269215ae8eaac00841e01e17a38273fa2'
AND (
token = 'X1O8qgrlV9p7tAnTeSz9u9T/icl78Vjzcl8LK3rx94A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)