UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cNlG1dYnjOpXvU4VWopRZXAhL2IZcY0oKaXAw3oai+s='
WHERE
key_id = '6991abcb0e05ca724c80d25c8459a05d978dd7edccb4d3a113acd9228355893b'
AND (
token = 'cNlG1dYnjOpXvU4VWopRZXAhL2IZcY0oKaXAw3oai+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)