UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQd4aBVzcR7gtHcDKPskMT6ZBXOV1DOnQ2phGnlZQWw='
WHERE
key_id = '1eafc49e1ce69b54ec7d87ff7017828677ccf40d1b07bcd5b231ea5acac64284'
AND (
token = 'pQd4aBVzcR7gtHcDKPskMT6ZBXOV1DOnQ2phGnlZQWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)