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