UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8y9Rx6xfhtVMVxMEUZxmEb5HIr2zaAtK8/dyzEHowAw='
WHERE
key_id = 'c65824ba0e3d6c0ffb322bc329d71b4d63856e48b985917ee7dfe64afd297f56'
AND (
token = '8y9Rx6xfhtVMVxMEUZxmEb5HIr2zaAtK8/dyzEHowAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)