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