UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZgJSoe6nNEUJx15wECObrA2HEUh00VqB+PVqdK0x0A='
WHERE
key_id = '4ec24d7041a11c14cba9478d3a19089671ebb2c621ccd9b956e6d8be2a4cef57'
AND (
token = 'hZgJSoe6nNEUJx15wECObrA2HEUh00VqB+PVqdK0x0A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)