UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPv1MMYq7EXiEf4Fao7rcFgHi53WNiDQGJ0aBNOYvX0='
WHERE
key_id = '01cb25a9f69f933e9d00cd765057ce31ecb94a6268ee2b439576b7feeff635a2'
AND (
token = 'gPv1MMYq7EXiEf4Fao7rcFgHi53WNiDQGJ0aBNOYvX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)