UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lsG7E12IzZnDPwxCgSr/lC6TlARop7GrVmpAw6b1XnI='
WHERE
key_id = 'fd7175c1995e3a6d15c644c2e186b574ab1b26c5efb2deb96e84be78fe802f5d'
AND (
token = 'lsG7E12IzZnDPwxCgSr/lC6TlARop7GrVmpAw6b1XnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)