UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WbzkJ9XYKSEPCaHwIo2M6aOEY9KdEvMRAhhlcC4mgY='
WHERE
key_id = '62b0bfab6928e53b322b70d37400f6f9f463d89d6470167e99b05a591185f897'
AND (
token = '7WbzkJ9XYKSEPCaHwIo2M6aOEY9KdEvMRAhhlcC4mgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)