UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o5I9rj1+AAV0yhI2sDvldc8b3qxhqXq76/G3St6BTeY='
WHERE
key_id = 'f152ee5ef83bf2aeccba0b2210006787b4151b267e3b202f1d6b76f90e1148f3'
AND (
token = 'o5I9rj1+AAV0yhI2sDvldc8b3qxhqXq76/G3St6BTeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)