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