UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgxLqhDKwAxrWFi1jUL4Y9/pfrDEWucg1ugXFe2rBk0='
WHERE
key_id = '99beebd0997711c9472640252474acf8a080662f17de6cfcf037637e8d1f5915'
AND (
token = 'lgxLqhDKwAxrWFi1jUL4Y9/pfrDEWucg1ugXFe2rBk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)