UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXTlN6KqmyAk0CZRrii4BOPI/MuFMx2vzn7Cg3jLxYs='
WHERE
key_id = 'c97103f7a425604bfc4bf955c8719a05a2c8e98c371918705b21d3d345cef5c6'
AND (
token = 'pXTlN6KqmyAk0CZRrii4BOPI/MuFMx2vzn7Cg3jLxYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)