UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KX2b5TbCUaMHIt2OrqlOv2wqnZMstT32uT2kSivQNPw='
WHERE
key_id = '02ce095b4857cdd7dce33887b644f748e18290e94f4ea48fcebbb59a0969d4c0'
AND (
token = 'KX2b5TbCUaMHIt2OrqlOv2wqnZMstT32uT2kSivQNPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)