UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '39z3ta4XoYL9qfhircZ1HjtA66ER/v8Uaq/fCcJLHYg='
WHERE
key_id = '3a75c631d0cdbfef1003b537edadc704585168630d1ed569454a8292cf64acdb'
AND (
token = '39z3ta4XoYL9qfhircZ1HjtA66ER/v8Uaq/fCcJLHYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)