UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2l6uXIoxCSsEVciphUWfW3L2minXmb17sS9fiTqGNu4='
WHERE
key_id = 'b4bc364cf081706db1403a3be1a62fd0320a494ee87c73a5d3cf51fdcfb8226d'
AND (
token = '2l6uXIoxCSsEVciphUWfW3L2minXmb17sS9fiTqGNu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)