UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'scE9UCw6afUl4u0/+wdGTD5nWE//nFTPUeHvft/8cs0='
WHERE
key_id = '2c5d9ee4bd87b0c28ffe5345e0a2f0bf90fb7d053d9fb87e0960fb4f07fce3a4'
AND (
token = 'scE9UCw6afUl4u0/+wdGTD5nWE//nFTPUeHvft/8cs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)