UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ppS3/xqFd9Im5pjhoTqDgkVO2L7lwn4uQFtA5Xb8QJA='
WHERE
key_id = 'c9d747445b468a55da114ec1d4abeb2967f80e32cd42b4f81a58a03b90b1e51e'
AND (
token = 'ppS3/xqFd9Im5pjhoTqDgkVO2L7lwn4uQFtA5Xb8QJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)