UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8733RC6Amv4YD5IJjsgeZOVsBr69llLYXteDcmQfWI='
WHERE
key_id = 'e547cde7fa0597d81581616e7b981dee6c1e92e0f2c85bb7d39321fc18037b10'
AND (
token = 'p8733RC6Amv4YD5IJjsgeZOVsBr69llLYXteDcmQfWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)