UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qaLpC3n02X7Km+l/zdHlKkFiiXs3NFOGnA9KDrmxERI='
WHERE
key_id = '781ef9ff30215206b1cf6b20e010acf448dd61f9078c23034bcb586d5154c09b'
AND (
token = 'qaLpC3n02X7Km+l/zdHlKkFiiXs3NFOGnA9KDrmxERI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)