UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J6DBE1i5U+aeoGqv/Ca1G44EY+OZ3qlX4PRsWKkSeC4='
WHERE
key_id = '27aaaf9d4fb79d22cd4189cd878ab2cf16e1a5afdb2e47fcd9b3be4da52c3a5f'
AND (
token = 'J6DBE1i5U+aeoGqv/Ca1G44EY+OZ3qlX4PRsWKkSeC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)