UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1UIN4pDSW3VroGQeRsKs979BJyrH3dKZQY4L7a42vCo='
WHERE
key_id = '47dbd7cd3161ed8aeacb158f550f52d6775cdc4711f0b9095cef6ac2fbd36fb0'
AND (
token = '1UIN4pDSW3VroGQeRsKs979BJyrH3dKZQY4L7a42vCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)