UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lnDJDKgosr0ebe1w5f9UFH7HxcTQD/njfzqTpPzQytQ='
WHERE
key_id = 'd2278c343caa767b3c766103e9015b4fe782c7407ba62ae819ff52e34d93b6d1'
AND (
token = 'lnDJDKgosr0ebe1w5f9UFH7HxcTQD/njfzqTpPzQytQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)