UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l9EcJqBVxWywC37Gsgo/w8idSjiyS9ROOeZbFS2ZF3A='
WHERE
key_id = 'd3eed20432ea00ad8a6e0eacfa97f308f12afe42fc009263c4c5988dc06b8ecf'
AND (
token = 'l9EcJqBVxWywC37Gsgo/w8idSjiyS9ROOeZbFS2ZF3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)