UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '00iQMJHG85RdFNndpzNTlwue0g95CskHUlurE/jwsAA='
WHERE
key_id = '4585949fb8e10f32ed9eaa308762da45976969ef743f9b8b16f78e54d393e89d'
AND (
token = '00iQMJHG85RdFNndpzNTlwue0g95CskHUlurE/jwsAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)